Excel 2019 for Biological and Life Sciences Statistics by Thomas J. Quirk & Meghan H. Quirk & Howard F. Horton

Author:Thomas J. Quirk & Meghan H. Quirk & Howard F. Horton
Language: eng
Format: epub
ISBN: 9783030392819
Publisher: Springer International Publishing

5.2.1 An Example of Formula #1 for the Two-Group t-Test

Now, let’s use Formula #1 in a situation in which both groups have a sample size greater than 30.

Suppose that a researcher wanted to identify the preference of laboratory mice, males and females, for a certain type of bait. The researcher wanted to develop a type of bait that targeted female mice more than male mice in order to increase the effectiveness of a pest control agent. Both groups of mice, males and females, were given samples of the same bait. The researcher recorded the number of times each mouse in each group ate some of the bait over a period of time.

Suppose the researcher collected the data and determined (using her new Excel skills) that the 52 male mice in this study had a mean result of 55 with a standard deviation of 7, while the 57 female mice in this study had a mean result of 64 with a standard deviation of 13.

Note that the two-group t-test does not require that both groups have the same sample size. This is another way of saying that the two-group t-test is “robust” (a fancy term that statisticians like to use).

The data then produced the following table in Fig. 5.7:

Fig. 5.7Worksheet Data for Mouse Study

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.